﻿CREATE TABLE [flcr].[CONTRACT_DETAIL] (
    [CONTRACT_DETAIL_ID]              INT              NOT NULL,
    [AUDIT_USER]                      VARCHAR (100)    NOT NULL,
    [AUDIT_DTTM]                      DATETIME         NOT NULL,
    [AUDIT_DTTM_TZ]                   INT              NOT NULL,
    [AUDIT_MOD_USER]                  VARCHAR (100)    NOT NULL,
    [AUDIT_MOD_DTTM]                  DATETIME         NOT NULL,
    [AUDIT_MOD_DTTM_TZ]               INT              NOT NULL,
    [RLS_MASK]                        VARBINARY (256)  NULL,
    [RLS_OWNER]                       UNIQUEIDENTIFIER NULL,
    [ACTIVE_FLG]                      BIT              NOT NULL,
    [SORT_ORDER]                      INT              NOT NULL,
    [CONTRACT_ID]                     INT              NOT NULL,
    [CONTRACT_DETAIL_IVALUE_CHECKSUM] VARCHAR (800)    NOT NULL,
    [CONTRACT_DETAIL_PROP_ID]         INT              NOT NULL,
    [CONTRACT_DETAIL_IVALUE]          VARCHAR (MAX)    NOT NULL
);

